home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Personal Computer World 2005 October
/
PCWOCT05.iso
/
Software
/
FromTheMag
/
XAMPP 1.4.14
/
xampp-win32-1.4.14-installer.exe
/
xampp
/
phpMyAdmin
/
libraries
/
config_import.lib.php
< prev
next >
Wrap
PHP Script
|
2005-03-05
|
33KB
|
1,286 lines
<?php
/* $Id: config_import.lib.php,v 2.42 2005/03/06 14:54:15 nijel Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
/**
* This file provides support for older config files.
*/
/**
* U S A G E
*
* After having added a new directive to the config.inc.php file, you need to
* put some backwards compatibility code into this file.
*
* This usually looks like this:
*
* if (!isset($myNewDirective)) {
* $myNewDirective = 'my default value';
* }
*
* If the new directive is meant as a replacement for an old one, please use the
* following layout:
*
* if (!isset($myNewDirective)) {
* if (isset($myOldDirective)) {
* $myNewDirective = $myOldDirective;
* unset($myOldDirective);
* } else {
* $myNewDirective = '';
* }
* }
*
* In order to make this file readable for other developers, please try to use
* the same order of directives here as you do in config.inc.php.
*
* After having done all this, search libraries/common.lib.php for the
* following paragraph (x and y are integers):
*
* if ($cfg['FileRevision'][0] < x || $cfg['FileRevision'][1] < y) {
* require_once('./libraries/config_import.lib.php');
* }
*
* Finally, set x and y to the _new_ revision number of config.inc.php and
* you're done! x would be the major version, y the minor version number of the
* new revision, e.g. 2.34 becomes: x = 2, y = 34
*/
if (!isset($cfg['PmaAbsoluteUri'])) {
if (isset($cfgPmaAbsoluteUri)) {
$cfg['PmaAbsoluteUri'] = $cfgPmaAbsoluteUri;
unset($cfgPmaAbsoluteUri);
} else {
$cfg['PmaAbsoluteUri'] = '';
}
}
if (!isset($cfg['PmaAbsoluteUri_DisableWarning'])) {
$cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
}
if (!isset($cfg['PmaNoRelation_DisableWarning'])) {
$cfg['PmaNoRelation_DisableWarning'] = FALSE;
}
// do not set a default value here!
if (!isset($cfg['blowfish_secret'])) {
$cfg['blowfish_secret'] = '';
}
if (!isset($cfg['Servers'])) {
if (isset($cfgServers)) {
$cfg['Servers'] = $cfgServers;
unset($cfgServers);
} else {
$server = 0;
}
}
if (isset($cfg['Servers'])) {
for ($i=1; (!empty($cfg['Servers'][$i]['host']) || (isset($cfg['Servers'][$i]['connect_type']) && $cfg['Servers'][$i]['connect_type'] == 'socket')); $i++) {
if (!isset($cfg['Servers'][$i]['host'])) {
$cfg['Servers'][$i]['host'] = '';
}
if (!isset($cfg['Servers'][$i]['port'])) {
$cfg['Servers'][$i]['port'] = '';
}
if (!isset($cfg['Servers'][$i]['socket'])) {
$cfg['Servers'][$i]['socket'] = '';
}
if (!isset($cfg['Servers'][$i]['connect_type'])) {
$cfg['Servers'][$i]['connect_type'] = 'tcp';
}
if (!isset($cfg['Servers'][$i]['extension'])) {
$cfg['Servers'][$i]['extension'] = 'mysql';
}
if (!isset($cfg['Servers'][$i]['controluser']) && isset($cfg['Servers'][$i]['stduser'])) {
$cfg['Servers'][$i]['controluser'] = $cfg['Servers'][$i]['stduser'];
$cfg['Servers'][$i]['controlpass'] = $cfg['Servers'][$i]['stdpass'];
unset($cfg['Servers'][$i]['stduser'], $cfg['Servers'][$i]['stdpass']);
} else if (!isset($cfg['Servers'][$i]['controluser'])) {
$cfg['Servers'][$i]['controluser'] = $cfg['Servers'][$i]['controlpass'] = '';
}
if (!isset($cfg['Servers'][$i]['auth_type'])) {
$cfg['Servers'][$i]['auth_type'] = (isset($cfg['Servers'][$i]['adv_auth']) && $cfg['Servers'][$i]['adv_auth'])
? 'http'
: 'config';
unset($cfg['Servers'][$i]['adv_auth']);
}
// for users who use the "first" blowfish mechanism
if (isset($cfg['Servers'][$i]['blowfish_secret'])) {
if (empty($cfg['blowfish_secret'])) {
$cfg['blowfish_secret'] = $cfg['Servers'][$i]['blowfish_secret'];
}
unset($cfg['Servers'][$i]['blowfish_secret']);
}
if (!isset($cfg['Servers'][$i]['compress'])) {
$cfg['Servers'][$i]['compress'] = FALSE;
}
if (!isset($cfg['Servers'][$i]['user'])) {
$cfg['Servers'][$i]['user'] = 'root';
}
if (!isset($cfg['Servers'][$i]['password'])) {
$cfg['Servers'][$i]['password'] = '';
}
if (!isset($cfg['Servers'][$i]['only_db'])) {
$cfg['Servers'][$i]['only_db'] = '';
}
if (!isset($cfg['Servers'][$i]['verbose'])) {
$cfg['Servers'][$i]['verbose'] = '';
}
if (!isset($cfg['Servers'][$i]['pmadb'])) {
if (isset($cfg['Servers'][$i]['bookmarkdb'])) {
$cfg['Servers'][$i]['pmadb'] = $cfg['Servers'][$i]['bookmarkdb'];
unset($cfg['Servers'][$i]['bookmarkdb']);
} else {
$cfg['Servers'][$i]['pmadb'] = '';
}
}
if (!isset($cfg['Servers'][$i]['bookmarktable'])) {
$cfg['Servers'][$i]['bookmarktable'] = '';
}
if (!isset($cfg['Servers'][$i]['relation'])) {
$cfg['Servers'][$i]['relation'] = '';
}
if (!isset($cfg['Servers'][$i]['table_info'])) {
$cfg['Servers'][$i]['table_info'] = '';
}
if (!isset($cfg['Servers'][$i]['table_coords'])) {
$cfg['Servers'][$i]['table_coords'] = '';
}
if (!isset($cfg['Servers'][$i]['column_info'])) {
if (isset($cfg['Servers'][$i]['column_comments'])) {
$cfg['Servers'][$i]['column_info'] = $cfg['Servers'][$i]['column_comments'];
unset($cfg['Servers'][$i]['column_comments']);
} else {
$cfg['Servers'][$i]['column_info'] = '';
}
}
if (!isset($cfg['Servers'][$i]['pdf_pages'])) {
$cfg['Servers'][$i]['pdf_pages'] = '';
}
if (!isset($cfg['Servers'][$i]['history'])) {
$cfg['Servers'][$i]['history'] = '';
}
if (!isset($cfg['Servers'][$i]['verbose_check'])) {
$cfg['Servers'][$i]['verbose_check'] = TRUE;
}
if (!isset($cfg['Servers'][$i]['AllowRoot'])) {
$cfg['Servers'][$i]['AllowRoot'] = TRUE;
}
if (!isset($cfg['Servers'][$i]['AllowDeny'])) {
$cfg['Servers'][$i]['AllowDeny'] = array ('order' => '',
'rules' => array());
}
}
}
if (!isset($cfg['ServerDefault'])) {
if (isset($cfgServerDefault)) {
$cfg['ServerDefault'] = $cfgServerDefault;
unset($cfgServerDefault);
} else {
$cfg['ServerDefault'] = 1;
}
}
if (!isset($cfg['OBGzip'])) {
if (isset($cfgOBGzip)) {
$cfg['OBGzip'] = $cfgOBGzip;
unset($cfgOBGzip);
} else {
$cfg['OBGzip'] = 'auto';
}
}
if (!isset($cfg['PersistentConnections'])) {
if (isset($cfgPersistentConnections)) {
$cfg['PersistentConnections'] = $cfgPersistentConnections;
unset($cfgPersistentConnections);
} else {
$cfg['PersistentConnections'] = FALSE;
}
}
if (!isset($cfg['ExecTimeLimit'])) {
if (isset($cfgExecTimeLimit)) {
$cfg['ExecTimeLimit'] = $cfgExecTimeLimit;
unset($cfgExecTimeLimit);
} else {
$cfg['ExecTimeLimit'] = 300;
}
}
if (!isset($cfg['SkipLockedTables'])) {
if (isset($cfgSkipLockedTables)) {
$cfg['SkipLockedTables'] = $cfgSkipLockedTables;
unset($cfgSkipLockedTables);
} else {
$cfg['SkipLockedTables'] = FALSE;
}
}
if (!isset($cfg['ShowSQL'])) {
if (isset($cfgShowSQL)) {
$cfg['ShowSQL'] = $cfgShowSQL;
unset($cfgShowSQL);
} else {
$cfg['ShowSQL'] = TRUE;
}
}
if (!isset($cfg['AllowUserDropDatabase'])) {
if (isset($cfgAllowUserDropDatabase)) {
$cfg['AllowUserDropDatabase'] = $cfgAllowUserDropDatabase;
unset($cfgAllowUserDropDatabase);
} else {
$cfg['AllowUserDropDatabase'] = FALSE;
}
}
if (!isset($cfg['Confirm'])) {
if (isset($cfgConfirm)) {
$cfg['Confirm'] = $cfgConfirm;
unset($cfgConfirm);
} else {
$cfg['Confirm'] = TRUE;
}
}
if (!isset($cfg['LoginCookieRecall'])) {
if (isset($cfgLoginCookieRecall)) {
$cfg['LoginCookieRecall'] = $cfgLoginCookieRecall;
unset($cfgLoginCookieRecall);
} else {
$cfg['LoginCookieRecall'] = TRUE;
}
}
if (!isset($cfg['LoginCookieValidity'])) {
$cfg['LoginCookieValidity'] = 1800;
}
if (!isset($cfg['UseDbSearch'])) {
$cfg['UseDbSearch'] = TRUE;
}
if (!isset($cfg['IgnoreMultiSubmitErrors'])) {
$cfg['IgnoreMultiSubmitErrors'] = FALSE;
}
if (!isset($cfg['VerboseMultiSubmit'])) {
$cfg['VerboseMultiSubmit'] = TRUE;
}
if (!isset($cfg['AllowArbitraryServer'])) {
$cfg['AllowArbitraryServer'] = FALSE;
}
if (!isset($cfg['LeftFrameLight'])) {
if (isset($cfgLeftFrameLight)) {
$cfg['LeftFrameLight'] = $cfgLeftFrameLight;
unset($cfgLeftFrameLight);
} else {
$cfg['LeftFrameLight'] = TRUE;
}
}
if (!isset($cfg['LeftFrameTableSeparator'])) {
$cfg['LeftFrameTableSeparator'] = '__';
}
if (!isset($cfg['LeftFrameTableLevel'])) {
$cfg['LeftFrameTableLevel'] = '1';
}
if (!isset($cfg['LightTabs'])) {
$cfg['LightTabs'] = FALSE;
}
if (!isset($cfg['PropertiesIconic'])) {
$cfg['PropertiesIconic'] = TRUE;
}
if (!isset($cfg['PropertiesNumColumns'])) {
$cfg['PropertiesNumColumns'] = 1;
}
if (!isset($cfg['ShowTooltip'])) {
if (isset($cfgShowTooltip)) {
$cfg['ShowTooltip'] = $cfgShowTooltip;
} else {
$cfg['ShowTooltip'] = TRUE;
}
}
if (!isset($cfg['LeftDisplayLogo'])) {
$cfg['LeftDisplayLogo'] = TRUE;
}
if (!isset($cfg['LeftDisplayServers'])) {
$cfg['LeftDisplayServers'] = FALSE;
}
if (!isset($cfg['DisplayServersList'])) {
if (isset($cfg['LeftisplayServersList'])) {
$cfg['DisplayServersList'] = $cfg['LeftDisplayServersList'];
} else {
$cfg['DisplayServersList'] = FALSE;
}
}
if (!isset($cfg['ShowStats'])) {
if (isset($cfgShowStats)) {
$cfg['ShowStats'] = $cfgShowStats;
unset($cfgShowStats);
} else {
$cfg['ShowStats'] = TRUE;
}
}
if (!isset($cfg['ShowMysqlInfo'])) {
if (isset($cfgShowMysqlInfo)) {
$cfg['ShowMysqlInfo'] = $cfgShowMysqlInfo;
unset($cfgShowMysqlInfo);
} else {
$cfg['ShowMysqlInfo'] = FALSE;
}
}
if (!isset($cfg['ShowMysqlVars'])) {
if (isset($cfgShowMysqlVars)) {
$cfg['ShowMysqlVars'] = $cfgShowMysqlVars;
unset($cfgShowMysqlVars);
} else {
$cfg['ShowMysqlVars'] = FALSE;
}
}
if (!isset($cfg['ShowPhpInfo'])) {
if (isset($cfgShowPhpInfo)) {
$cfg['ShowPhpInfo'] = $cfgShowPhpInfo;
unset($cfgShowPhpInfo);
} else {
$cfg['ShowPhpInfo'] = FALSE;
}
}
if (!isset($cfg['ShowChgPassword'])) {
if (isset($cfgShowChgPassword)) {
$cfg['ShowChgPassword'] = $cfgShowChgPassword;
unset($cfgShowChgPassword);
} else {
$cfg['ShowChgPassword'] = FALSE;
}
}
if (!isset($cfg['SuggestDBName'])) {
$cfg['SuggestDBName'] = TRUE;
}
if (!isset($cfg['ShowBlob'])) {
if (isset($cfgShowBlob)) {
$cfg['ShowBlob'] = $cfgShowBlob;
unset($cfgShowBlob);
} else {
$cfg['ShowBlob'] = FALSE;
}
}
if (!isset($cfg['NavigationBarIconic'])) {
if (isset($cfgNavigationBarIconic)) {
$cfg['NavigationBarIconic'] = $cfgNavigationBarIconic;
unset($cfgNavigationBarIconic);
} else {
$cfg['NavigationBarIconic'] = TRUE;
}
}
if (!isset($cfg['ShowAll'])) {
if (isset($cfgShowAll)) {
$cfg['ShowAll'] = $cfgShowAll;
unset($cfgShowAll);
} else {
$cfg['ShowAll'] = FALSE;
}
}
if (!isset($cfg['MaxRows'])) {
if (isset($cfgMaxRows)) {
$cfg['MaxRows'] = $cfgMaxRows;
unset($cfgMaxRows);
} else {
$cfg['MaxRows'] = 30;
}
}
if (!isset($cfg['Order'])) {
if (isset($cfgOrder)) {
$cfg['Order'] = $cfgOrder;
unset($cfgOrder);
} else {
$cfg['Order'] = 'ASC';
}
}
if (!isset($cfg['ProtectBinary'])) {
if (isset($cfgProtectBinary)) {
$cfg['ProtectBinary'] = $cfgProtectBinary;
unset($cfgProtectBinary);
} else if (isset($cfg['ProtectBlob'])) {
$cfg['ProtectBinary'] = ($cfg['ProtectBlob'] ? 'blob' : FALSE);
unset($cfg['ProtectBlob']);
} else if (isset($cfgProtectBlob)) {
$cfg['ProtectBinary'] = ($cfgProtectBlob ? 'blob' : FALSE);
unset($cfgProtectBlob);
} else {
$cfg['ProtectBinary'] = 'blob';
}
}
if (!isset($cfg['ShowFunctionFields'])) {
if (isset($cfgShowFunctionFields)) {
$cfg['ShowFunctionFields'] = $cfgShowFunctionFields;
unset($cfgShowFunctionFields);
} else {
$cfg['ShowFunctionFields'] = TRUE;
}
}
if (!isset($cfg['CharEditing'])) {
$cfg['CharEditing'] = 'input';
}
if (!isset($cfg['InsertRows'])) {
$cfg['InsertRows'] = 2;
}
if (!isset($cfg['ZipDump'])) {
if (isset($cfgZipDump)) {
$cfg['ZipDump'] = $cfgZipDump;
unset($cfgZipDump);
} else {
$cfg['ZipDump'] = TRUE;
}
}
if (!isset($cfg['GZipDump'])) {
if (isset($cfgGZipDump)) {
$cfg['GZipDump'] = $cfgGZipDump;
unset($cfgGZipDump);
} else {
$cfg['GZipDump'] = TRUE;
}
}
if (!isset($cfg['BZipDump'])) {
if (isset($cfgBZipDump)) {
$cfg['BZipDump'] = $cfgBZipDump;
unset($cfgBZipDump);
} else {
$cfg['BZipDump'] = TRUE;
}
}
if (!isset($cfg['CompressOnFly'])) {
$cfg['CompressOnFly'] = TRUE;
}
if (!isset($cfg['DefaultTabServer'])) {
$cfg['DefaultTabServer'] = 'main.php';
}
if (!isset($cfg['DefaultTabDatabase'])
// rabus: config.inc.php rev. 1.112 had this default value.
|| $cfg['DefaultTabDatabase'] == 'Structure') {
$cfg['DefaultTabDatabase'] = 'db_details_structure.php';
}
if (!isset($cfg['DefaultTabTable'])
// rabus: config.inc.php rev. 1.112 had this default value.
|| $cfg['DefaultTabTable'] == 'Structure') {
$cfg['DefaultTabTable'] = 'tbl_properties_structure.php';
}
if (!isset($cfg['MySQLManualBase'])) {
if (isset($cfgManualBaseShort)) {
$cfg['MySQLManualBase'] = $cfgManualBaseShort;
$cfg['MySQLManualType'] = 'old';
unset($cfgManualBaseShort);
} else if (isset($cfg['ManualBaseShort'])) {
$cfg['MySQLManualBase'] = $cfg['ManualBaseShort'];
$cfg['MySQLManualType'] = 'old';
unset($cfg['ManualBaseShort']);
} else {
$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en';
$cfg['MySQLManualType'] = 'searchable';
}
}
if (!isset($cfg['MySQLManualType'])) {
$cfg['MySQLManualType'] = 'none';
}
if (!isset($cfg['DefaultLang'])) {
if (isset($cfgDefaultLang)) {
$cfg['DefaultLang'] = $cfgDefaultLang;
unset($cfgDefaultLang);
} else {
$cfg['DefaultLang'] = 'en-iso-8859-1';
}
}
if (!isset($cfg['DefaultCharset'])) {
$cfg['DefaultCharset'] = 'iso-8859-1';
}
if (!isset($cfg['AllowAnywhereRecoding'])) {
$cfg['AllowAnywhereRecoding'] = FALSE;
}
if (!isset($cfg['RecodingEngine'])) {
$cfg['RecodingEngine'] = 'auto';
}
if (!isset($cfg['IconvExtraParams'])) {
$cfg['IconvExtraParams'] = '';
}
if (!isset($cfg['Lang']) &&isset($cfgLang)) {
$cfg['Lang'] = $cfgLang;
unset($cfgLang);
}
if (!isset($cfg['LeftPointerEnable'])) {
$cfg['LeftPointerEnable'] = TRUE;
}
if (!isset($cfg['BrowsePointerEnable'])) {
$cfg['BrowsePointerEnable'] = TRUE;
}
if (!isset($cfg['BrowseMarkerEnable'])) {
$cfg['BrowseMarkerEnable'] = TRUE;
}
if (!isset($cfg['TextareaCols'])) {
if (isset($cfgTextareaCols)) {
$cfg['TextareaCols'] = $cfgTextareaCols;
unset($cfgTextareaCols);
} else {
$cfg['TextareaCols'] = 40;
}
}
if (!isset($cfg['LongtextDoubleTextarea'])) {
$cfg['LongtextDoubleTextarea'] = TRUE;
}
if (!isset($cfg['TextareaRows'])) {
if (isset($cfgTextareaRows)) {
$cfg['TextareaRows'] = $cfgTextareaRows;
unset($cfgTextareaRows);
} else {
$cfg['TextareaRows'] = 7;
}
}
if (!isset($cfg['TextareaAutoSelect'])) {
$cfg['TextareaAutoSelect'] = TRUE;
}
if (!isset($cfg['CharTextareaCols'])) {
$cfg['CharTextareaCols'] = 40;
}
if (!isset($cfg['CharTextareaRows'])) {
$cfg['CharTextareaRows'] = 2;
}
if (!isset($cfg['LimitChars'])) {
if (isset($cfgLimitChars)) {
$cfg['LimitChars'] = $cfgLimitChars;
unset($cfgLimitChars);
} else {
$cfg['LimitChars'] = 50;
}
}
if (!isset($cfg['ModifyDeleteAtLeft'])) {
if (isset($cfgModifyDeleteAtLeft)) {
$cfg['ModifyDeleteAtLeft'] = $cfgModifyDeleteAtLeft;
unset($cfgModifyDeleteAtLeft);
} else {
$cfg['ModifyDeleteAtLeft'] = TRUE;
}
}
if (!isset($cfg['ModifyDeleteAtRight'])) {
if (isset($cfgModifyDeleteAtRight)) {
$cfg['ModifyDeleteAtRight'] = $cfgModifyDeleteAtRight;
unset($cfgModifyDeleteAtRight);
} else {
$cfg['ModifyDeleteAtRight'] = FALSE;
}
}
if (!isset($cfg['DefaultDisplay'])) {
if (isset($cfgDefaultDisplay)) {
$cfg['DefaultDisplay'] = $cfgDefaultDisplay;
unset($cfgDefaultDisplay);
} else {
$cfg['DefaultDisplay'] = 'horizontal';
}
}
if (!isset($cfg['DefaultPropDisplay'])) {
$cfg['DefaultPropDisplay'] = 'horizontal';
}
if (!isset($cfg['RepeatCells'])) {
if (isset($cfgRepeatCells)) {
$cfg['RepeatCells'] = $cfgRepeatCells;
unset($cfgRepeatCells);
} else {
$cfg['RepeatCells'] = 100;
}
}
if (!isset($cfg['HeaderFlipType'])) {
$cfg['HeaderFlipType'] = 'css';
}
if (!isset($cfg['ShowBrowseComments'])) {
$cfg['ShowBrowseComments'] = TRUE;
}
if (!isset($cfg['ShowPropertyComments'])) {
$cfg['ShowPropertyComments'] = TRUE;
}
if (!isset($cfg['QueryFrame'])) {
$cfg['QueryFrame'] = TRUE;
}
if (!isset($cfg['QueryFrameJS'])) {
$cfg['QueryFrameJS'] = TRUE;
}
if (!isset($cfg['QueryWindowWidth'])) {
$cfg['QueryWindowWidth'] = 550;
}
if (!isset($cfg['QueryWindowHeight'])) {
$cfg['QueryWindowHeight'] = 310;
}
if (!isset($cfg['QueryHistoryMax'])) {
$cfg['QueryHistoryMax'] = 25;
}
if (!isset($cfg['QueryHistoryDB'])) {
$cfg['QueryHistoryDB'] = FALSE;
}
if (!isset($cfg['QueryWindowDefTab'])) {
$cfg['QueryWindowDefTab'] = 'sql';
}
if (!isset($cfg['BrowseMIME'])) {
$cfg['BrowseMIME'] = TRUE;
}
if (!isset($cfg['MaxExactCount'])) {
$cfg['MaxExactCount'] = 20000;
}
if (!isset($cfg['WYSIWYG-PDF'])) {
$cfg['WYSIWYG-PDF'] = TRUE;
}
if (!isset($cfg['NaturalOrder'])) {
$cfg['NaturalOrder'] = TRUE;
}
if (!isset($cfg['ShowHttpHostTitle'])) {
$cfg['ShowHttpHostTitle'] = FALSE;
}
if (!isset($cfg['SetHttpHostTitle'])) {
$cfg['SetHttpHostTitle'] = '';
}
if (!isset($cfg['ErrorIconic'])) {
$cfg['ErrorIconic'] = TRUE;
}
if (!isset($cfg['MainPageIconic'])) {
$cfg['MainPageIconic'] = TRUE;
}
if (!isset($cfg['ReplaceHelpImg'])) {
$cfg['ReplaceHelpImg'] = TRUE;
}
if (!isset($cfg['ThemePath'])) {
$cfg['ThemePath'] = './themes';
$cfg['ThemeDefault'] = 'original';
$cfg['ThemeManager'] = TRUE;
} else {
if (!isset($cfg['ThemeDefault'])){
$cfg['ThemeDefault'] = 'original';
}
if (!isset($cfg['ThemeManager'])){
$cfg['ThemeManager'] = TRUE;
}
}
if (!isset($cfg['DefaultQueryTable'])) {
$cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1';
}
if (!isset($cfg['DefaultQueryDatabase'])) {
$cfg['DefaultQueryDatabase']= '';
}
if (!isset($cfg['ShowTooltipAliasDB'])) {
$cfg['ShowTooltipAliasDB'] = FALSE;
}
if (!isset($cfg['ShowTooltipAliasTB'])) {
$cfg['ShowTooltipAliasTB'] = FALSE;
}
if (!isset($cfg['SQLQuery']['Edit'])) {
$cfg['SQLQuery']['Edit'] = TRUE;
}
if (!isset($cfg['SQLQuery']['Explain'])) {
$cfg['SQLQuery']['Explain'] = TRUE;
}
if (!isset($cfg['SQLQuery']['ShowAsPHP'])) {
$cfg['SQLQuery']['ShowAsPHP'] = TRUE;
}
if (!isset($cfg['SQLQuery']['Validate'])) {
$cfg['SQLQuery']['Validate'] = FALSE;
}
if (!isset($cfg['SQLQuery']['Refresh'])) {
$cfg['SQLQuery']['Refresh'] = TRUE;
}
if (!isset($cfg['UploadDir'])) {
$cfg['UploadDir'] = '';
}
if (!isset($cfg['SaveDir'])) {
$cfg['SaveDir'] = '';
}
if (!isset($cfg['docSQLDir'])) {
$cfg['docSQLDir'] = '';
}
if (!isset($cfg['TempDir'])) {
$cfg['TempDir'] = '';
}
if (!isset($cfg['SQLValidator']['use'])) {
$cfg['SQLValidator']['use'] = FALSE;
}
if (!isset($cfg['SQLValidator']['username'])) {
$cfg['SQLValidator']['username'] = '';
}
if (!isset($cfg['SQLValidator']['password'])) {
$cfg['SQLValidator']['password'] = '';
}
if (!isset($cfg['DBG']['enable'])) {
$cfg['DBG']['enable'] = FALSE;
}
if (!isset($cfg['DBG']['profile']['enable'])) {
$cfg['DBG']['profile']['enable'] = FALSE;
}
if (!isset($cfg['DBG']['profile']['threshold'])) {
$cfg['DBG']['profile']['threshold'] = 0.5;
}
if (!isset($cfg['SQP']['fmtType'])) {
$cfg['SQP']['fmtType'] = 'html';
}
if (!isset($cfg['SQP']['fmtInd'])) {
$cfg['SQP']['fmtInd'] = '1';
}
if (!isset($cfg['SQP']['fmtIndUnit'])) {
$cfg['SQP']['fmtIndUnit'] = 'em';
}
if (!isset($cfg['AvailableCharsets'])) {
$cfg['AvailableCharsets'] = array(
'iso-8859-1',
'iso-8859-2',
'iso-8859-3',
'iso-8859-4',
'iso-8859-5',
'iso-8859-6',
'iso-8859-7',
'iso-8859-8',
'iso-8859-9',
'iso-8859-10',
'iso-8859-11',
'iso-8859-12',
'iso-8859-13',
'iso-8859-14',
'iso-8859-15',
'windows-1250',
'windows-1251',
'windows-1252',
'windows-1256',
'windows-1257',
'koi8-r',
'big5',
'gb2312',
'gbk',
'utf-8',
'utf-7',
'x-user-defined',
'euc-jp',
'ks_c_5601-1987',
'tis-620',
'SHIFT_JIS'
);
}
if (!isset($cfg['ColumnTypes'])) {
if (isset($cfgColumnTypes)) {
$cfg['ColumnTypes'] = $cfgColumnTypes;
unset($cfgColumnTypes);
} else {
$cfg['ColumnTypes'] = array(
'VARCHAR',
'TINYINT',
'TEXT',
'DATE',
'SMALLINT',
'MEDIUMINT',
'INT',
'BIGINT',
'FLOAT',
'DOUBLE',
'DECIMAL',
'DATETIME',
'TIMESTAMP',
'TIME',
'YEAR',
'CHAR',
'TINYBLOB',
'TINYTEXT',
'BLOB',
'MEDIUMBLOB',
'MEDIUMTEXT',
'LONGBLOB',
'LONGTEXT',
'ENUM',
'SET'
);
}
}
if (!isset($cfg['AttributeTypes'])) {
if (isset($cfgAttributeTypes)) {
$cfg['AttributeTypes'] = $cfgAttributeTypes;
unset($cfgAttributeTypes);
} else {
$cfg['AttributeTypes'] = array(
'',
'BINARY',
'UNSIGNED',
'UNSIGNED ZEROFILL'
);
}
}
if ($cfg['ShowFunctionFields']) {
if (!isset($cfg['Functions'])) {
if (isset($cfgFunctions)) {
$cfg['Functions'] = $cfgFunctions;
} else {
$cfg['Functions'] = array(
'ASCII',
'CHAR',
'SOUNDEX',
'LCASE',
'UCASE',
'NOW',
'OLD_PASSWORD',
'PASSWORD',
'MD5',
'SHA1',
'ENCRYPT',
'RAND',
'LAST_INSERT_ID',
'COUNT',
'AVG',
'SUM',
'CURDATE',
'CURTIME',
'FROM_DAYS',
'FROM_UNIXTIME',
'PERIOD_ADD',
'PERIOD_DIFF',
'TO_DAYS',
'UNIX_TIMESTAMP',
'USER',
'WEEKDAY',
'CONCAT'
);
}
// Which column types will be mapped to which Group?
$cfg['RestrictColumnTypes'] = array(
'VARCHAR' => 'FUNC_CHAR',
'TINYINT' => 'FUNC_NUMBER',
'TEXT' => 'FUNC_CHAR',
'DATE' => 'FUNC_DATE',
'SMALLINT' => 'FUNC_NUMBER',
'MEDIUMINT' => 'FUNC_NUMBER',
'INT' => 'FUNC_NUMBER',
'BIGINT' => 'FUNC_NUMBER',
'FLOAT' => 'FUNC_NUMBER',
'DOUBLE' => 'FUNC_NUMBER',
'DECIMAL' => 'FUNC_NUMBER',
'DATETIME' => 'FUNC_DATE',
'TIMESTAMP' => 'FUNC_DATE',
'TIME' => 'FUNC_DATE',
'YEAR' => 'FUNC_DATE',
'CHAR' => 'FUNC_CHAR',
'TINYBLOB' => 'FUNC_CHAR',
'TINYTEXT' => 'FUNC_CHAR',
'BLOB' => 'FUNC_CHAR',
'MEDIUMBLOB' => 'FUNC_CHAR',
'MEDIUMTEXT' => 'FUNC_CHAR',
'LONGBLOB' => 'FUNC_CHAR',
'LONGTEXT' => 'FUNC_CHAR',
'ENUM' => '',
'SET' => ''
);
// Map above defined groups to any function
$cfg['RestrictFunctions'] = array(
'FUNC_CHAR' => array(
'ASCII',
'CHAR',
'SOUNDEX',
'LCASE',
'UCASE',
'OLD_PASSWORD',
'PASSWORD',
'MD5',
'SHA1',
'ENCRYPT',
'LAST_INSERT_ID',
'USER',
'CONCAT'
),
'FUNC_DATE' => array(
'NOW',
'CURDATE',
'CURTIME',
'FROM_DAYS',
'FROM_UNIXTIME',
'PERIOD_ADD',
'PERIOD_DIFF',
'TO_DAYS',
'UNIX_TIMESTAMP',
'WEEKDAY'
),
'FUNC_NUMBER' => array(
'ASCII',
'CHAR',
'MD5',
'SHA1',
'ENCRYPT',
'RAND',
'LAST_INSERT_ID',
'UNIX_TIMESTAMP',
'COUNT',
'AVG',
'SUM'
)
);
}
if (!isset($cfg['DefaultFunctions'])) {
$cfg['DefaultFunctions'] = array(
'FUNC_CHAR' => '',
'FUNC_DATE' => '',
'FUNC_NUMBER' => '',
'first_timestamp' => 'NOW'
);
}
}
if (!isset($cfg['NumOperators'])) {
$cfg['NumOperators'] = array(
'=',
'>',
'>=',
'<',
'<=',
'!=',
'LIKE',
'NOT LIKE'
);
}
if (!isset($cfg['TextOperators'])) {
$cfg['TextOperators'] = array(
'LIKE',
'LIKE %...%',
'NOT LIKE',
'=',
'!=',
'REGEXP',
'NOT REGEXP'
);
}
if (!isset($cfg['EnumOperators'])) {
$cfg['EnumOperators'] = array(
'=',
'!='
);
}
if (!isset($cfg['NullOperators'])) {
$cfg['NullOperators'] = array(
'IS NULL',
'IS NOT NULL'
);
}
if (!isset($cfg['UnaryOperators'])) {
$cfg['UnaryOperators'] = array(
'IS NULL' => 1,
'IS NOT NULL' => 1
);
}
if (!isset($cfg['GD2Available'])) {
$cfg['GD2Available'] = 'auto';
}
if (!isset($cfg['PDFPageSizes'])) {
$cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal');
}
if (!isset($cfg['PDFDefaultPageSize'])) {
$cfg['PDFDefaultPageSize'] = 'A4';
}
if (!isset($cfg['CtrlArrowsMoving'])) {
$cfg['CtrlArrowsMoving'] = TRUE;
}
if (!isset($cfg['Export'])) {
$cfg['Export'] = array();
}
if (!isset($cfg['Export']['format'])) {
$cfg['Export']['format'] = 'sql';
} // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword
if (!isset($cfg['Export']['compression'])) {
$cfg['Export']['compression'] = 'none';
} // none/zip/gzip/bzip2
if (!isset($cfg['Export']['asfile'])) {
$cfg['Export']['asfile'] = FALSE;
}
if (!isset($cfg['Export']['onserver'])) {
$cfg['Export']['onserver'] = FALSE;
}
if (!isset($cfg['Export']['onserver_overwrite'])) {
$cfg['Export']['onserver_overwrite'] = FALSE;
}
if (!isset($cfg['Export']['remember_file_template'])) {
$cfg['Export']['remember_file_template'] = TRUE;
}
if (!isset($cfg['Export']['csv_null'])) {
$cfg['Export']['csv_null'] = 'NULL';
}
if (!isset($cfg['Export']['csv_columns'])) {
$cfg['Export']['csv_columns'] = FALSE;
}
if (!isset($cfg['Export']['htmlexcel_null'])) {
$cfg['Export']['htmlexcel_null'] = 'NULL';
}
if (!isset($cfg['Export']['htmlexcel_columns'])) {
$cfg['Export']['htmlexcel_columns'] = FALSE;
}
if (!isset($cfg['Export']['htmlword_structure'])) {
$cfg['Export']['htmlword_structure'] = TRUE;
}
if (!isset($cfg['Export']['htmlword_data'])) {
$cfg['Export']['htmlword_data'] = TRUE;
}
if (!isset($cfg['Export']['htmlword_null'])) {
$cfg['Export']['htmlword_null'] = 'NULL';
}
if (!isset($cfg['Export']['htmlword_columns'])) {
$cfg['Export']['htmlword_columns'] = FALSE;
}
if (!isset($cfg['Export']['xls_null'])) {
$cfg['Export']['xls_null'] = 'NULL';
}
if (!isset($cfg['Export']['xls_columns'])) {
$cfg['Export']['xls_columns'] = FALSE;
}
if (!isset($cfg['Export']['excel_null'])) {
$cfg['Export']['excel_null'] = 'NULL';
}
if (!isset($cfg['Export']['excel_columns'])) {
$cfg['Export']['excel_columns'] = FALSE;
}
if (!isset($cfg['Export']['excel_edition'])) {
$cfg['Export']['excel_edition'] = 'win';
}
if (!isset($cfg['Export']['latex_null'])) {
$cfg['Export']['latex_null'] = '\textit{NULL}';
}
if (!isset($cfg['Export']['csv_separator'])) {
$cfg['Export']['csv_separator'] = ';';
}
if (!isset($cfg['Export']['csv_enclosed'])) {
$cfg['Export']['csv_enclosed'] = '"';
}
if (!isset($cfg['Export']['csv_escaped'])) {
$cfg['Export']['csv_escaped'] = '\\';
}
if (!isset($cfg['Export']['csv_terminated'])) {
$cfg['Export']['csv_terminated'] = 'AUTO';
}
if (!isset($cfg['Export']['latex_structure'])) {
$cfg['Export']['latex_structure'] = TRUE;
}
if (!isset($cfg['Export']['latex_data'])) {
$cfg['Export']['latex_data'] = TRUE;
}
if (!isset($cfg['Export']['latex_columns'])) {
$cfg['Export']['latex_columns'] = TRUE;
}
if (!isset($cfg['Export']['latex_relation'])) {
$cfg['Export']['latex_relation'] = TRUE;
}
if (!isset($cfg['Export']['latex_comments'])) {
$cfg['Export']['latex_comments'] = TRUE;
}
if (!isset($cfg['Export']['latex_mime'])) {
$cfg['Export']['latex_mime'] = TRUE;
}
if (!isset($cfg['Export']['latex_caption'])) {
$cfg['Export']['latex_caption'] = TRUE;
}
if (!isset($cfg['Export']['latex_data_label'])) {
$cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data';
}
if (!isset($cfg['Export']['latex_structure_label'])) {
$cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure';
}
if (!isset($cfg['Export']['sql_drop_database'])) {
$cfg['Export']['sql_drop_database'] = FALSE;
}
if (!isset($cfg['Export']['sql_disable_fk'])) {
$cfg['Export']['sql_disable_fk'] = FALSE;
}
if (!isset($cfg['Export']['sql_use_transaction'])) {
$cfg['Export']['sql_use_transaction'] = FALSE;
}
if (!isset($cfg['Export']['sql_drop_table'])) {
$cfg['Export']['sql_drop_table'] = FALSE;
}
if (!isset($cfg['Export']['sql_if_not_exists'])) {
$cfg['Export']['sql_if_not_exists'] = FALSE;
}
if (!isset($cfg['Export']['sql_auto_increment'])) {
$cfg['Export']['sql_auto_increment'] = TRUE;
}
if (!isset($cfg['Export']['sql_structure'])) {
$cfg['Export']['sql_structure'] = TRUE;
}
if (!isset($cfg['Export']['sql_data'])) {
$cfg['Export']['sql_data'] = TRUE;
}
if (!isset($cfg['Export']['sql_compat'])) {
$cfg['Export']['sql_compat'] = 'NONE';
}
if (!isset($cfg['Export']['sql_backquotes'])) {
$cfg['Export']['sql_backquotes'] = TRUE;
}
if (!isset($cfg['Export']['sql_dates'])) {
$cfg['Export']['sql_dates'] = FALSE;
}
if (!isset($cfg['Export']['sql_relation'])) {
$cfg['Export']['sql_relation'] = FALSE;
}
if (!isset($cfg['Export']['sql_columns'])) {
$cfg['Export']['sql_columns'] = FALSE;
}
if (!isset($cfg['Export']['sql_delayed'])) {
$cfg['Export']['sql_delayed'] = FALSE;
}
if (!isset($cfg['Export']['sql_ignore'])) {
$cfg['Export']['sql_ignore'] = FALSE;
}
if (!isset($cfg['Export']['sql_hex_for_binary'])) {
$cfg['Export']['sql_hex_for_binary'] = TRUE;
}
if (!isset($cfg['Export']['sql_type'])) {
$cfg['Export']['sql_type'] = 'insert';
}
if (!isset($cfg['Export']['sql_extended'])) {
$cfg['Export']['sql_extended'] = FALSE;
}
if (!isset($cfg['Export']['sql_comments'])) {
$cfg['Export']['sql_comments'] = FALSE;
}
if (!isset($cfg['Export']['sql_mime'])) {
$cfg['Export']['sql_mime'] = FALSE;
}
if (!isset($cfg['Export']['sql_header_comment'])) {
$cfg['Export']['sql_header_comment'] = '';
}
?>